Skip to main content

ws[wsid]

Row Record Data db.ws + WorksheetId

{
"_id":"ObjectID",
"rowid":"string", // Row record ID
"wsid": "string", // Worksheet ID
"autoid":"int", // Autonumber
"status": "int", // Status. 1: Normal, 9: Deleted, 999: Completely deleted
"cid[Control ID]":"object", // Column value. Store data in different formats depending on the control type
"cid[Control ID]":"object", // Column value. Store data in different formats depending on the control type
"relations":"[{
"cid":"string", // Control ID
"wsid":"string", // Associated worksheet ID
"rows":"[string]", // Associated row record IDs
}]", // Old associative memory, no longer used in any edition after 2021
"rc"+cid:["rowid"], // List of associated row records
"ot"+cid:"{
"idx":"int", // Sort index
"score":"double" // Score
}", // Index and score of options
"sharerange":"int", // Sharing scope. 1: Sharing disabled, 2: Visible to public, 3: Visible to members
"ctime":"datetime", // Date created
"caid":"string", // Creator account ID
"ownerid":"string", // Owner account ID
"utime":"datetime", // Date edited
"dtime":"datetime", // Date deleted
"users":["aid"], // Redundant search for joiners
"owners":["aid"], // Redundant search for owners
"keyworks":"string", // Search for keywords
}